reset
!create P1 : Professor
!create A1 : Aluno
!create Dis1 : Disciplina
!create Dis2 : Disciplina
!create Area1 : AreaCientifica
!create Perf1 : Perfil
!create Date1 : CalendarDate
!create Dep1 : Departamento
!create Sec1 : Seccao
!create C1 : Curso

!insert (Dis2,Dis2) into Disciplina_Disciplina
!insert (P1,Dis2) into Professor_Docencia
!insert (P1,Dis2) into Professor_Regencia
!insert (Dis2,Area1) into Disciplina_AreaCientifica

!create Oferta1 : Oferta between (Dis1,Perf1)
!create Matricula1 : Matricula between (A1,Perf1)
!create Inscricao1 : Inscricao between (A1,Dis1)
!insert (Dis1,Area1) into Disciplina_AreaCientifica
!insert (P1,Sec1) into Professor_Seccao
!insert (Dep1,Sec1) into Departamento_Seccao
!insert (C1,P1) into Curso_CCientifica
!insert (C1,P1) into Curso_Coordenacao
!insert (C1,P1) into Curso_Erasmus
!insert (P1,Dis1) into Professor_Docencia
!insert (P1,Dis1) into Professor_Regencia
!insert (C1,Perf1) into Curso_Perfil
!insert (Dis1,Dis1) into Disciplina_Disciplina
!set Oferta1.ects := 1
!set Inscricao1.resultado := 20